package com.company;

import com.company.dao.UserDao;
import com.company.dao.impl.UserDaoImpl;

public class Main {

    public static void main(String[] args) {
        String sql = "SELECT * \n" +
                "FROM `user`\n" +
                "WHERE username LIKE '李%'";

        UserDao userDao = new UserDaoImpl();
        userDao.userXing(sql);
    }
}
//	    Dao dao = new Dao();
//        dao.coon();
//        dao.close();

// statement = coonection.prepareStatement(sql);
//         // 4. 执行SQL查询 并获取结果
//         rs = statement.executeQuery();
//         while (rs.next()){ // 迭代器
//         int id = rs.getInt("id");
//         String username = rs.getString("username");
//         String password = rs.getString("password");
//         String birthday = rs.getString("birthday");
//         System.out.println("ID:"+id+"\tpassword:"+password+"\tusername" +
//         ":"+username+"\tbirthday:"+birthday);
//         }
